car price

Dataset statistics

Number of variables	16
Number of observations	18648
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	1225
Duplicate rows (%)	6.6%
Total size in memory	2.4 MiB
Average record size in memory	136.0 B

Variable types

Text	3
Numeric	5
Categorical	7
Boolean	1

Alerts

Dataset has 1225 (6.6%) duplicate rows	Duplicates
`Doors` is highly imbalanced (81.2%)	Imbalance
`Wheel` is highly imbalanced (60.5%)	Imbalance
`Mileage` is highly skewed (γ1 = 38.29564934)	Skewed
`Mileage` has 703 (3.8%) zeros	Zeros
`Airbags` has 2355 (12.6%) zeros	Zeros

Reproduction

Analysis started	2024-10-11 09:50:10.087833
Analysis finished	2024-10-11 09:50:13.794885
Duration	3.71 seconds
Software version	ydata-profiling vv4.10.0
Download configuration	config.json

Manufacturer
Text

Distinct	63
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	291.4 KiB

Length

Max length	13
Median length	11
Mean length	6.8181574
Min length	3

Characters and Unicode

Total characters	127145
Distinct characters	31
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row	LEXUS
2nd row	CHEVROLET
3rd row	HONDA
4th row	FORD
5th row	HONDA

Value	Count	Frequency (%)
hyundai	3700	19.8%
toyota	3583	19.2%
mercedes-benz	1979	10.6%
ford	1060	5.7%
chevrolet	1043	5.6%
bmw	997	5.3%
honda	956	5.1%
lexus	895	4.8%
nissan	645	3.5%
volkswagen	571	3.1%
Other values (55)	3259	17.4%

Most occurring characters

Value	Count	Frequency (%)
E	12517	9.8%
O	12103	9.5%
A	11703	9.2%
N	9595	7.5%
T	8681	6.8%
D	8472	6.7%
Y	7754	6.1%
S	6658	5.2%
I	6300	5.0%
H	6073	4.8%
Other values (21)	37289	29.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	127145	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	12517	9.8%
O	12103	9.5%
A	11703	9.2%
N	9595	7.5%
T	8681	6.8%
D	8472	6.7%
Y	7754	6.1%
S	6658	5.2%
I	6300	5.0%
H	6073	4.8%
Other values (21)	37289	29.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	127145	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	12517	9.8%
O	12103	9.5%
A	11703	9.2%
N	9595	7.5%
T	8681	6.8%
D	8472	6.7%
Y	7754	6.1%
S	6658	5.2%
I	6300	5.0%
H	6073	4.8%
Other values (21)	37289	29.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	127145	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	12517	9.8%
O	12103	9.5%
A	11703	9.2%
N	9595	7.5%
T	8681	6.8%
D	8472	6.7%
Y	7754	6.1%
S	6658	5.2%
I	6300	5.0%
H	6073	4.8%
Other values (21)	37289	29.3%

Model
Text

Distinct	1536
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Memory size	291.4 KiB

Length

Max length	24
Median length	23
Mean length	5.8558559
Min length	1

Characters and Unicode

Total characters	109200
Distinct characters	98
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	913 ?
Unique (%)	4.9%

Sample

1st row	RX 450
2nd row	Equinox
3rd row	FIT
4th row	Escape
5th row	FIT

Value	Count	Frequency (%)
prius	1243	5.2%
sonata	1093	4.6%
camry	1002	4.2%
elantra	950	4.0%
350	923	3.9%
e	834	3.5%
santa	505	2.1%
fe	505	2.1%
fit	469	2.0%
h1	435	1.8%
Other values (1050)	15816	66.5%

Most occurring characters

Value	Count	Frequency (%)
a	11309	10.4%
r	6993	6.4%
t	6241	5.7%
n	5686	5.2%
	5127	4.7%
i	4670	4.3%
o	4465	4.1%
s	4122	3.8%
e	3914	3.6%
0	3815	3.5%
Other values (88)	52858	48.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109200	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	11309	10.4%
r	6993	6.4%
t	6241	5.7%
n	5686	5.2%
	5127	4.7%
i	4670	4.3%
o	4465	4.1%
s	4122	3.8%
e	3914	3.6%
0	3815	3.5%
Other values (88)	52858	48.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109200	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	11309	10.4%
r	6993	6.4%
t	6241	5.7%
n	5686	5.2%
	5127	4.7%
i	4670	4.3%
o	4465	4.1%
s	4122	3.8%
e	3914	3.6%
0	3815	3.5%
Other values (88)	52858	48.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109200	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	11309	10.4%
r	6993	6.4%
t	6241	5.7%
n	5686	5.2%
	5127	4.7%
i	4670	4.3%
o	4465	4.1%
s	4122	3.8%
e	3914	3.6%
0	3815	3.5%
Other values (88)	52858	48.4%

Prod. year
Real number (ℝ)

Distinct	53
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2010.8446

Minimum	1939
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	291.4 KiB

Quantile statistics

Minimum	1939
5-th percentile	1999
Q1	2009
median	2012
Q3	2014
95-th percentile	2017
Maximum	2020
Range	81
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	5.6426016
Coefficient of variation (CV)	0.0028060853
Kurtosis	10.654647
Mean	2010.8446
Median Absolute Deviation (MAD)	3
Skewness	-2.0324607
Sum	37498231
Variance	31.838952
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2012	2119	11.4%
2014	2059	11.0%
2013	1895	10.2%
2011	1577	8.5%
2015	1492	8.0%
2010	1460	7.8%
2016	1402	7.5%
2017	909	4.9%
2008	729	3.9%
2009	594	3.2%
Other values (43)	4412	23.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1939	3	< 0.1%
1947	1	< 0.1%
1953	4	< 0.1%
1957	1	< 0.1%
1964	2	< 0.1%
1965	2	< 0.1%
1968	1	< 0.1%
1973	1	< 0.1%
1974	1	< 0.1%
1976	1	< 0.1%

Value	Count	Frequency (%)
2020	28	0.2%
2019	273	1.5%
2018	455	2.4%
2017	909	4.9%
2016	1402	7.5%
2015	1492	8.0%
2014	2059	11.0%
2013	1895	10.2%
2012	2119	11.4%
2011	1577	8.5%

Category
Categorical

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	291.4 KiB

Sedan	8548
Jeep	5193
Hatchback	2797
Minivan	628
Coupe	513
Other values (6)	969

Length

Max length	11
Median length	9
Mean length	5.5978121
Min length	4

Characters and Unicode

Total characters	104388
Distinct characters	30
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jeep
2nd row	Jeep
3rd row	Hatchback
4th row	Jeep
5th row	Hatchback

Common Values

Value	Count	Frequency (%)
Sedan	8548	45.8%
Jeep	5193	27.8%
Hatchback	2797	15.0%
Minivan	628	3.4%
Coupe	513	2.8%
Universal	357	1.9%
Microbus	295	1.6%
Goods wagon	227	1.2%
Pickup	46	0.2%
Cabriolet	33	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sedan	8548	45.3%
jeep	5193	27.5%
hatchback	2797	14.8%
minivan	628	3.3%
coupe	513	2.7%
universal	357	1.9%
microbus	295	1.6%
goods	227	1.2%
wagon	227	1.2%
pickup	46	0.2%
Other values (2)	44	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	19848	19.0%
a	15387	14.7%
n	10399	10.0%
d	8775	8.4%
S	8548	8.2%
c	5935	5.7%
p	5752	5.5%
J	5193	5.0%
b	3125	3.0%
k	2843	2.7%
Other values (20)	18583	17.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	104388	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	19848	19.0%
a	15387	14.7%
n	10399	10.0%
d	8775	8.4%
S	8548	8.2%
c	5935	5.7%
p	5752	5.5%
J	5193	5.0%
b	3125	3.0%
k	2843	2.7%
Other values (20)	18583	17.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	104388	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	19848	19.0%
a	15387	14.7%
n	10399	10.0%
d	8775	8.4%
S	8548	8.2%
c	5935	5.7%
p	5752	5.5%
J	5193	5.0%
b	3125	3.0%
k	2843	2.7%
Other values (20)	18583	17.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	104388	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	19848	19.0%
a	15387	14.7%
n	10399	10.0%
d	8775	8.4%
S	8548	8.2%
c	5935	5.7%
p	5752	5.5%
J	5193	5.0%
b	3125	3.0%
k	2843	2.7%
Other values (20)	18583	17.8%

Leather interior
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	163.9 KiB

True	13471
False	5177

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	13471	72.2%
False	5177	27.8%

Fuel type
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	291.4 KiB

Petrol	9763
Diesel	3912
Hybrid	3534
LPG	885
CNG	469
Other values (2)	85

Length

Max length	14
Median length	6
Mean length	5.8183183
Min length	3

Characters and Unicode

Total characters	108500
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Hybrid
2nd row	Petrol
3rd row	Petrol
4th row	Hybrid
5th row	Petrol

Common Values

Value	Count	Frequency (%)
Petrol	9763	52.4%
Diesel	3912	21.0%
Hybrid	3534	19.0%
LPG	885	4.7%
CNG	469	2.5%
Plug-in Hybrid	84	0.5%
Hydrogen	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
petrol	9763	52.1%
diesel	3912	20.9%
hybrid	3618	19.3%
lpg	885	4.7%
cng	469	2.5%
plug-in	84	0.4%
hydrogen	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	17588	16.2%
l	13759	12.7%
r	13382	12.3%
P	10732	9.9%
o	9764	9.0%
t	9763	9.0%
i	7614	7.0%
D	3912	3.6%
s	3912	3.6%
d	3619	3.3%
Other values (12)	14455	13.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	108500	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	17588	16.2%
l	13759	12.7%
r	13382	12.3%
P	10732	9.9%
o	9764	9.0%
t	9763	9.0%
i	7614	7.0%
D	3912	3.6%
s	3912	3.6%
d	3619	3.3%
Other values (12)	14455	13.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	108500	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	17588	16.2%
l	13759	12.7%
r	13382	12.3%
P	10732	9.9%
o	9764	9.0%
t	9763	9.0%
i	7614	7.0%
D	3912	3.6%
s	3912	3.6%
d	3619	3.3%
Other values (12)	14455	13.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	108500	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	17588	16.2%
l	13759	12.7%
r	13382	12.3%
P	10732	9.9%
o	9764	9.0%
t	9763	9.0%
i	7614	7.0%
D	3912	3.6%
s	3912	3.6%
d	3619	3.3%
Other values (12)	14455	13.3%

Engine volume
Text

Distinct	103
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	291.4 KiB

Length

Max length	9
Median length	3
Mean length	3.0397898
Min length	1

Characters and Unicode

Total characters	56686
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	0.1%

Sample

1st row	3.5
2nd row	3
3rd row	1.3
4th row	2.5
5th row	1.3

Value	Count	Frequency (%)
2	3836	18.8%
2.5	2325	11.4%
1.8	1918	9.4%
turbo	1770	8.7%
1.6	1562	7.7%
1.5	1351	6.6%
3.5	1192	5.8%
2.4	1023	5.0%
3	806	3.9%
1.3	533	2.6%
Other values (59)	4102	20.1%

Most occurring characters

Value	Count	Frequency (%)
.	13708	24.2%
2	9151	16.1%
1	6398	11.3%
5	5137	9.1%
3	3684	6.5%
4	2409	4.2%
6	2094	3.7%
8	2058	3.6%
o	1770	3.1%
	1770	3.1%
Other values (7)	8507	15.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	56686	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
.	13708	24.2%
2	9151	16.1%
1	6398	11.3%
5	5137	9.1%
3	3684	6.5%
4	2409	4.2%
6	2094	3.7%
8	2058	3.6%
o	1770	3.1%
	1770	3.1%
Other values (7)	8507	15.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	56686	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
.	13708	24.2%
2	9151	16.1%
1	6398	11.3%
5	5137	9.1%
3	3684	6.5%
4	2409	4.2%
6	2094	3.7%
8	2058	3.6%
o	1770	3.1%
	1770	3.1%
Other values (7)	8507	15.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	56686	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
.	13708	24.2%
2	9151	16.1%
1	6398	11.3%
5	5137	9.1%
3	3684	6.5%
4	2409	4.2%
6	2094	3.7%
8	2058	3.6%
o	1770	3.1%
	1770	3.1%
Other values (7)	8507	15.0%

Mileage
Real number (ℝ)

SKEWED ZEROS

Distinct	7594
Distinct (%)	40.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1577387.2

Minimum	0
Maximum	2.1474836 × 10⁹
Zeros	703
Zeros (%)	3.8%
Negative	0
Negative (%)	0.0%
Memory size	291.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2261.9
Q1	71298.5
median	127515
Q3	190000
95-th percentile	321187.8
Maximum	2.1474836 × 10⁹
Range	2.1474836 × 10⁹
Interquartile range (IQR)	118701.5

Descriptive statistics

Standard deviation	49161708
Coefficient of variation (CV)	31.166545
Kurtosis	1549.6717
Mean	1577387.2
Median Absolute Deviation (MAD)	58533
Skewness	38.295649
Sum	2.9415116 × 10¹⁰
Variance	2.4168736 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	703	3.8%
200000	180	1.0%
150000	157	0.8%
160000	119	0.6%
180000	115	0.6%
100000	104	0.6%
1000	100	0.5%
170000	98	0.5%
120000	96	0.5%
130000	83	0.4%
Other values (7584)	16893	90.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	703	3.8%
13	1	< 0.1%
18	1	< 0.1%
98	1	< 0.1%
120	1	< 0.1%
261	1	< 0.1%
429	1	< 0.1%
498	1	< 0.1%
500	6	< 0.1%
554	1	< 0.1%

Value	Count	Frequency (%)
2147483647	7	< 0.1%
1777777778	1	< 0.1%
1234567899	1	< 0.1%
1111111111	2	< 0.1%
999999999	5	< 0.1%
777777777	1	< 0.1%
222222222	1	< 0.1%
111111111	1	< 0.1%
58008888	1	< 0.1%
55556665	1	< 0.1%

Cylinders
Real number (ℝ)

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5612398

Minimum	1
Maximum	16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	291.4 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	4
median	4
Q3	4
95-th percentile	8
Maximum	16
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.1777705
Coefficient of variation (CV)	0.25821281
Kurtosis	6.8389633
Mean	4.5612398
Median Absolute Deviation (MAD)	0
Skewness	2.1328936
Sum	85058
Variance	1.3871435
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
4	14055	75.4%
6	3279	17.6%
8	906	4.9%
5	168	0.9%
3	107	0.6%
2	42	0.2%
1	36	0.2%
12	32	0.2%
10	12	0.1%
16	5	< 0.1%
Other values (3)	6	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	36	0.2%
2	42	0.2%
3	107	0.6%
4	14055	75.4%
5	168	0.9%
6	3279	17.6%
7	4	< 0.1%
8	906	4.9%
9	1	< 0.1%
10	12	0.1%

Value	Count	Frequency (%)
16	5	< 0.1%
14	1	< 0.1%
12	32	0.2%
10	12	0.1%
9	1	< 0.1%
8	906	4.9%
7	4	< 0.1%
6	3279	17.6%
5	168	0.9%
4	14055	75.4%

Gear box type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	291.4 KiB

Automatic	13152
Tiptronic	2932
Manual	1833
Variator	731

Length

Max length	9
Median length	9
Mean length	8.6659159
Min length	6

Characters and Unicode

Total characters	161602
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Automatic
2nd row	Tiptronic
3rd row	Variator
4th row	Automatic
5th row	Automatic

Common Values

Value	Count	Frequency (%)
Automatic	13152	70.5%
Tiptronic	2932	15.7%
Manual	1833	9.8%
Variator	731	3.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
automatic	13152	70.5%
tiptronic	2932	15.7%
manual	1833	9.8%
variator	731	3.9%

Most occurring characters

Value	Count	Frequency (%)
t	29967	18.5%
i	19747	12.2%
a	18280	11.3%
o	16815	10.4%
c	16084	10.0%
u	14985	9.3%
A	13152	8.1%
m	13152	8.1%
n	4765	2.9%
r	4394	2.7%
Other values (5)	10261	6.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	161602	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	29967	18.5%
i	19747	12.2%
a	18280	11.3%
o	16815	10.4%
c	16084	10.0%
u	14985	9.3%
A	13152	8.1%
m	13152	8.1%
n	4765	2.9%
r	4394	2.7%
Other values (5)	10261	6.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	161602	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	29967	18.5%
i	19747	12.2%
a	18280	11.3%
o	16815	10.4%
c	16084	10.0%
u	14985	9.3%
A	13152	8.1%
m	13152	8.1%
n	4765	2.9%
r	4394	2.7%
Other values (5)	10261	6.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	161602	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	29967	18.5%
i	19747	12.2%
a	18280	11.3%
o	16815	10.4%
c	16084	10.0%
u	14985	9.3%
A	13152	8.1%
m	13152	8.1%
n	4765	2.9%
r	4394	2.7%
Other values (5)	10261	6.3%

Drive wheels
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	291.4 KiB

Front	12620
4x4	3812
Rear	2216

Length

Max length	5
Median length	5
Mean length	4.4723295
Min length	3

Characters and Unicode

Total characters	83400
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4x4
2nd row	4x4
3rd row	Front
4th row	4x4
5th row	Front

Common Values

Value	Count	Frequency (%)
Front	12620	67.7%
4x4	3812	20.4%
Rear	2216	11.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
front	12620	67.7%
4x4	3812	20.4%
rear	2216	11.9%

Most occurring characters

Value	Count	Frequency (%)
r	14836	17.8%
F	12620	15.1%
o	12620	15.1%
n	12620	15.1%
t	12620	15.1%
4	7624	9.1%
x	3812	4.6%
R	2216	2.7%
e	2216	2.7%
a	2216	2.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	83400	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	14836	17.8%
F	12620	15.1%
o	12620	15.1%
n	12620	15.1%
t	12620	15.1%
4	7624	9.1%
x	3812	4.6%
R	2216	2.7%
e	2216	2.7%
a	2216	2.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	83400	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	14836	17.8%
F	12620	15.1%
o	12620	15.1%
n	12620	15.1%
t	12620	15.1%
4	7624	9.1%
x	3812	4.6%
R	2216	2.7%
e	2216	2.7%
a	2216	2.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	83400	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	14836	17.8%
F	12620	15.1%
o	12620	15.1%
n	12620	15.1%
t	12620	15.1%
4	7624	9.1%
x	3812	4.6%
R	2216	2.7%
e	2216	2.7%
a	2216	2.7%

Doors
Categorical

IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	291.4 KiB

04-May	17781
02-Mar	751
>5	116

Length

Max length	6
Median length	6
Mean length	5.975118
Min length	2

Characters and Unicode

Total characters	111424
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	04-May
2nd row	04-May
3rd row	04-May
4th row	04-May
5th row	04-May

Common Values

Value	Count	Frequency (%)
04-May	17781	95.4%
02-Mar	751	4.0%
>5	116	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
04-may	17781	95.4%
02-mar	751	4.0%
5	116	0.6%

Most occurring characters

Value	Count	Frequency (%)
0	18532	16.6%
-	18532	16.6%
M	18532	16.6%
a	18532	16.6%
4	17781	16.0%
y	17781	16.0%
2	751	0.7%
r	751	0.7%
>	116	0.1%
5	116	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	111424	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	18532	16.6%
-	18532	16.6%
M	18532	16.6%
a	18532	16.6%
4	17781	16.0%
y	17781	16.0%
2	751	0.7%
r	751	0.7%
>	116	0.1%
5	116	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	111424	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	18532	16.6%
-	18532	16.6%
M	18532	16.6%
a	18532	16.6%
4	17781	16.0%
y	17781	16.0%
2	751	0.7%
r	751	0.7%
>	116	0.1%
5	116	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	111424	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	18532	16.6%
-	18532	16.6%
M	18532	16.6%
a	18532	16.6%
4	17781	16.0%
y	17781	16.0%
2	751	0.7%
r	751	0.7%
>	116	0.1%
5	116	0.1%

Wheel
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	291.4 KiB

Left wheel	17196
Right-hand drive	1452

Length

Max length	16
Median length	10
Mean length	10.467181
Min length	10

Characters and Unicode

Total characters	195192
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Left wheel
2nd row	Left wheel
3rd row	Right-hand drive
4th row	Left wheel
5th row	Left wheel

Common Values

Value	Count	Frequency (%)
Left wheel	17196	92.2%
Right-hand drive	1452	7.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
left	17196	46.1%
wheel	17196	46.1%
right-hand	1452	3.9%
drive	1452	3.9%

Most occurring characters

Value	Count	Frequency (%)
e	53040	27.2%
h	20100	10.3%
t	18648	9.6%
	18648	9.6%
L	17196	8.8%
f	17196	8.8%
w	17196	8.8%
l	17196	8.8%
i	2904	1.5%
d	2904	1.5%
Other values (7)	10164	5.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	195192	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	53040	27.2%
h	20100	10.3%
t	18648	9.6%
	18648	9.6%
L	17196	8.8%
f	17196	8.8%
w	17196	8.8%
l	17196	8.8%
i	2904	1.5%
d	2904	1.5%
Other values (7)	10164	5.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	195192	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	53040	27.2%
h	20100	10.3%
t	18648	9.6%
	18648	9.6%
L	17196	8.8%
f	17196	8.8%
w	17196	8.8%
l	17196	8.8%
i	2904	1.5%
d	2904	1.5%
Other values (7)	10164	5.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	195192	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	53040	27.2%
h	20100	10.3%
t	18648	9.6%
	18648	9.6%
L	17196	8.8%
f	17196	8.8%
w	17196	8.8%
l	17196	8.8%
i	2904	1.5%
d	2904	1.5%
Other values (7)	10164	5.2%

Color
Categorical

Distinct	16
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	291.4 KiB

Black	4843
White	4310
Silver	3716
Grey	2302
Blue	1365
Other values (11)	2112

Length

Max length	13
Median length	5
Mean length	5.0586122
Min length	3

Characters and Unicode

Total characters	94333
Distinct characters	29
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Silver
2nd row	Black
3rd row	Black
4th row	White
5th row	Silver

Common Values

Value	Count	Frequency (%)
Black	4843	26.0%
White	4310	23.1%
Silver	3716	19.9%
Grey	2302	12.3%
Blue	1365	7.3%
Red	620	3.3%
Green	320	1.7%
Orange	250	1.3%
Brown	181	1.0%
Carnelian red	176	0.9%
Other values (6)	565	3.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
black	4843	25.6%
white	4310	22.7%
silver	3716	19.6%
grey	2302	12.2%
blue	1487	7.8%
red	796	4.2%
green	320	1.7%
orange	250	1.3%
brown	181	1.0%
carnelian	176	0.9%
Other values (6)	565	3.0%

Most occurring characters

Value	Count	Frequency (%)
e	14228	15.1%
l	10610	11.2%
i	8360	8.9%
r	7160	7.6%
B	6522	6.9%
a	5445	5.8%
k	4990	5.3%
c	4843	5.1%
W	4310	4.6%
h	4310	4.6%
Other values (19)	23555	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	94333	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	14228	15.1%
l	10610	11.2%
i	8360	8.9%
r	7160	7.6%
B	6522	6.9%
a	5445	5.8%
k	4990	5.3%
c	4843	5.1%
W	4310	4.6%
h	4310	4.6%
Other values (19)	23555	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	94333	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	14228	15.1%
l	10610	11.2%
i	8360	8.9%
r	7160	7.6%
B	6522	6.9%
a	5445	5.8%
k	4990	5.3%
c	4843	5.1%
W	4310	4.6%
h	4310	4.6%
Other values (19)	23555	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	94333	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	14228	15.1%
l	10610	11.2%
i	8360	8.9%
r	7160	7.6%
B	6522	6.9%
a	5445	5.8%
k	4990	5.3%
c	4843	5.1%
W	4310	4.6%
h	4310	4.6%
Other values (19)	23555	25.0%

Airbags
Real number (ℝ)

ZEROS

Distinct	17
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5448305

Minimum	0
Maximum	16
Zeros	2355
Zeros (%)	12.6%
Negative	0
Negative (%)	0.0%
Memory size	291.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	6
Q3	12
95-th percentile	12
Maximum	16
Range	16
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	4.3145391
Coefficient of variation (CV)	0.65922854
Kurtosis	-1.3298157
Mean	6.5448305
Median Absolute Deviation (MAD)	4
Skewness	0.092351365
Sum	122048
Variance	18.615248
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
4	5663	30.4%
12	5411	29.0%
0	2355	12.6%
8	1559	8.4%
6	1276	6.8%
2	1049	5.6%
10	828	4.4%
5	103	0.6%
16	85	0.5%
7	84	0.5%
Other values (7)	235	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2355	12.6%
1	76	0.4%
2	1049	5.6%
3	37	0.2%
4	5663	30.4%
5	103	0.6%
6	1276	6.8%
7	84	0.5%
8	1559	8.4%
9	61	0.3%

Value	Count	Frequency (%)
16	85	0.5%
15	6	< 0.1%
14	20	0.1%
13	2	< 0.1%
12	5411	29.0%
11	33	0.2%
10	828	4.4%
9	61	0.3%
8	1559	8.4%
7	84	0.5%

price_levy_combined
Real number (ℝ)

Distinct	7452
Distinct (%)	40.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16450.774

Minimum	1
Maximum	74809
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	291.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1111
Q1	5663
median	13485
Q3	22125
95-th percentile	46217.15
Maximum	74809
Range	74808
Interquartile range (IQR)	16462

Descriptive statistics

Standard deviation	14138.254
Coefficient of variation (CV)	0.85942787
Kurtosis	1.7121123
Mean	16450.774
Median Absolute Deviation (MAD)	8154
Skewness	1.324667
Sum	3.0677403 × 10⁸
Variance	1.9989022 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7840	173	0.9%
10976	141	0.8%
9408	126	0.7%
14113	122	0.7%
17249	112	0.6%
8467	93	0.5%
7213	92	0.5%
6272	91	0.5%
20385	91	0.5%
18817	90	0.5%
Other values (7442)	17517	93.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3	8	< 0.1%
6	3	< 0.1%
9	1	< 0.1%
19	1	< 0.1%
20	7	< 0.1%
25	16	0.1%
28	1	< 0.1%
30	76	0.4%
34	1	< 0.1%

Value	Count	Frequency (%)
74809	1	< 0.1%
74802	1	< 0.1%
74791	1	< 0.1%
74733	1	< 0.1%
74717	7	< 0.1%
74699	1	< 0.1%
74589	1	< 0.1%
74494	1	< 0.1%
74407	1	< 0.1%
74389	1	< 0.1%

Auto

Heatmap
Table

	Airbags	Category	Color	Cylinders	Doors	Drive wheels	Fuel type	Gear box type	Leather interior	Mileage	Prod. year	Wheel	price_levy_combined
Airbags	1.000	0.149	0.102	0.206	0.124	0.282	0.195	0.332	0.467	-0.028	0.174	0.316	-0.056
Category	0.149	1.000	0.094	0.123	0.441	0.438	0.234	0.334	0.378	0.008	0.195	0.328	0.125
Color	0.102	0.094	1.000	0.067	0.077	0.124	0.183	0.128	0.207	0.032	0.110	0.126	0.080
Cylinders	0.206	0.123	0.067	1.000	0.059	0.458	0.087	0.136	0.206	0.170	-0.179	0.089	-0.038
Doors	0.124	0.441	0.077	0.059	1.000	0.159	0.077	0.210	0.123	0.000	0.161	0.014	0.036
Drive wheels	0.282	0.438	0.124	0.458	0.159	1.000	0.182	0.242	0.089	0.008	0.240	0.023	0.110
Fuel type	0.195	0.234	0.183	0.087	0.077	0.182	1.000	0.228	0.185	0.041	0.162	0.148	0.162
Gear box type	0.332	0.334	0.128	0.136	0.210	0.242	0.228	1.000	0.463	0.028	0.322	0.211	0.180
Leather interior	0.467	0.378	0.207	0.206	0.123	0.089	0.185	0.463	1.000	0.037	0.365	0.346	0.269
Mileage	-0.028	0.008	0.032	0.170	0.000	0.008	0.041	0.028	0.037	1.000	-0.344	0.023	-0.191
Prod. year	0.174	0.195	0.110	-0.179	0.161	0.240	0.162	0.322	0.365	-0.344	1.000	0.236	0.287
Wheel	0.316	0.328	0.126	0.089	0.014	0.023	0.148	0.211	0.346	0.023	0.236	1.000	0.247
price_levy_combined	-0.056	0.125	0.080	-0.038	0.036	0.110	0.162	0.180	0.269	-0.191	0.287	0.247	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Manufacturer	Model	Prod. year	Category	Leather interior	Fuel type	Engine volume	Mileage	Cylinders	Gear box type	Drive wheels	Doors	Wheel	Color	Airbags	price_levy_combined
0	LEXUS	RX 450	2010	Jeep	Yes	Hybrid	3.5	186005	6.0	Automatic	4x4	04-May	Left wheel	Silver	12	14727
1	CHEVROLET	Equinox	2011	Jeep	No	Petrol	3	192000	6.0	Tiptronic	4x4	04-May	Left wheel	Black	8	17639
2	HONDA	FIT	2006	Hatchback	No	Petrol	1.3	200000	4.0	Variator	Front	04-May	Right-hand drive	Black	2	8467
3	FORD	Escape	2011	Jeep	Yes	Hybrid	2.5	168966	4.0	Automatic	4x4	04-May	Left wheel	White	0	4469
4	HONDA	FIT	2014	Hatchback	Yes	Petrol	1.3	91901	4.0	Automatic	Front	04-May	Left wheel	Silver	4	12172
5	HYUNDAI	Santa FE	2016	Jeep	Yes	Diesel	2	160931	4.0	Automatic	Front	04-May	Left wheel	White	4	40384
6	TOYOTA	Prius	2010	Hatchback	Yes	Hybrid	1.8	258909	4.0	Automatic	Front	04-May	Left wheel	White	12	2564
7	HYUNDAI	Sonata	2013	Sedan	Yes	Petrol	2.4	216118	4.0	Automatic	Front	04-May	Left wheel	Grey	12	1300
8	TOYOTA	Camry	2014	Sedan	Yes	Hybrid	2.5	398069	4.0	Automatic	Front	04-May	Left wheel	Black	12	1492
9	LEXUS	RX 350	2007	Jeep	Yes	Petrol	3.5	128500	6.0	Automatic	4x4	04-May	Left wheel	Silver	12	26657

	Manufacturer	Model	Prod. year	Category	Leather interior	Fuel type	Engine volume	Mileage	Cylinders	Gear box type	Drive wheels	Doors	Wheel	Color	Airbags	price_levy_combined
18914	MERCEDES-BENZ	E 350	2014	Sedan	Yes	Diesel	3.5	219030	6.0	Automatic	4x4	04-May	Left wheel	Black	12	30846
18915	MERCEDES-BENZ	E 350	2008	Sedan	Yes	Diesel	3.5	122874	6.0	Automatic	Rear	04-May	Left wheel	Black	12	2556
18916	TOYOTA	Prius	2008	Hatchback	No	Hybrid	1.5	150000	4.0	Automatic	Front	04-May	Left wheel	Silver	6	50
18917	TOYOTA	Prius	2011	Hatchback	Yes	Hybrid	1.8	307325	4.0	Automatic	Front	04-May	Left wheel	Silver	12	1115
18918	MERCEDES-BENZ	E 350	2013	Sedan	Yes	Diesel	3.5	107800	6.0	Automatic	Rear	04-May	Left wheel	Grey	12	6857
18919	MERCEDES-BENZ	CLK 200	1999	Coupe	Yes	CNG	2.0 Turbo	300000	4.0	Manual	Rear	02-Mar	Left wheel	Silver	5	8467
18920	HYUNDAI	Sonata	2011	Sedan	Yes	Petrol	2.4	161600	4.0	Tiptronic	Front	04-May	Left wheel	Red	8	16512
18921	HYUNDAI	Tucson	2010	Jeep	Yes	Diesel	2	116365	4.0	Automatic	Front	04-May	Left wheel	Grey	4	26944
18922	CHEVROLET	Captiva	2007	Jeep	Yes	Diesel	2	51258	4.0	Automatic	Front	04-May	Left wheel	Black	4	6619
18923	HYUNDAI	Sonata	2012	Sedan	Yes	Hybrid	2.4	186923	4.0	Automatic	Front	04-May	Left wheel	White	12	1223

Most frequently occurring

	Manufacturer	Model	Prod. year	Category	Leather interior	Fuel type	Engine volume	Mileage	Cylinders	Gear box type	Drive wheels	Doors	Wheel	Color	Airbags	price_levy_combined	# duplicates
1101	TOYOTA	Camry	2018	Sedan	Yes	Hybrid	2.5	35058	4.0	Automatic	Front	04-May	Left wheel	White	12	19426	24
1067	TOYOTA	Camry	2012	Sedan	Yes	Hybrid	2.5	314373	4.0	Automatic	Front	04-May	Left wheel	Grey	12	1173	23
1092	TOYOTA	Camry	2014	Sedan	Yes	Hybrid	2.5	179381	4.0	Automatic	Front	04-May	Left wheel	Black	12	11527	23
1064	TOYOTA	Camry	2012	Sedan	Yes	Hybrid	2.5	156518	4.0	Automatic	Front	04-May	Left wheel	White	12	4388	22
1076	TOYOTA	Camry	2013	Sedan	Yes	Hybrid	2.5	190549	4.0	Automatic	Front	04-May	Left wheel	Black	12	5797	22
1087	TOYOTA	Camry	2014	Sedan	Yes	Hybrid	2.5	102397	4.0	Automatic	Front	04-May	Left wheel	Black	12	1178	22
1093	TOYOTA	Camry	2014	Sedan	Yes	Hybrid	2.5	398069	4.0	Automatic	Front	04-May	Left wheel	Black	12	1492	21
1065	TOYOTA	Camry	2012	Sedan	Yes	Hybrid	2.5	159379	4.0	Automatic	Front	04-May	Left wheel	White	12	3917	20
1091	TOYOTA	Camry	2014	Sedan	Yes	Hybrid	2.5	130478	4.0	Automatic	Front	04-May	Left wheel	White	12	1256	20
854	MERCEDES-BENZ	E 300	2017	Sedan	Yes	Petrol	2	26802	4.0	Automatic	Rear	04-May	Left wheel	Black	12	1331	19

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)